DECLARE @String VARCHAR(1000) = '苹果,香蕉,橙子,葡萄'

DECLARE @String VARCHAR(1000) = '苹果,香蕉,橙子,葡萄'

SELECT id,
    LTRIM(RTRIM(Split.a.value('.', 'VARCHAR(100)'))) AS Value
FROM 
(
    SELECT  id, CAST('<X>'+REPLACE(CAST(zrr AS NVARCHAR(MAX)), ',', '</X><X>')+'</X>' AS XML) AS String from formtable_main_736_dt1 where mainid=1754
) AS A
CROSS APPLY String.nodes('/X') AS Split(a)


select  zrr from formtable_main_736_dt1 b where b.mainid=1754


SELECT id, [value] = CONVERT(xml,'<root><v>' + REPLACE([value], ',', '</v><v>') + '</v></root>') FROM (
								select    id ,cast(zrr as varchar(max)) as value from formtable_main_736_dt1 o1 with(nolock) where mainid=1754  )tt
                
                
                
                SELECT A.id, B.value  userid FROM( SELECT id, [value] = CONVERT(xml,'<root><v>' + REPLACE([value], ',', '</v><v>') + '</v></root>') FROM (
								select    id ,cast(zrr as varchar(max)) as value from formtable_main_736_dt1 o1 with(nolock)   where mainid=1754
						)tt)A  OUTER APPLY( SELECT value = N.v.value('.', 'varchar(100)') FROM A.[value].nodes('/root/v') N(v))B